Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_2371

R_2371

PhStOrderItemChange

PhStOrderItem

StOrderItemChangeID

 

 

R_2375

R_2375

PhDrugFormula

PhDrugProd

DrugFormulaID

 

 

R_2376

R_2376

PhDrugFormulaItem

PhDrugProdItem

DrugFormulaItemID

 

 

R_2377

R_2377

PhDrugFormulaItem

PhLDrugFormulaItemRes

DrugFormulaItemID

 

 

R_2378

R_2378

PhResource

PhLDrugFormulaItemRes

ResourceID

 

 

R_2379

R_2379

PhDrugProdItem

PhLDrugProdItLotInSt

DrugProdItemID

 

 

R_2380

R_2380

PhLotInSt

PhLDrugProdItLotInSt

LotInStID

 

 

R_2381

R_2381

PhStItem

PhDrugFormulaItem

StItemID

 

 

R_2385

R_2385

PhStItem

PhStOrderItem

StItemID

 

 

R_2390

R_2390

PhTradeDoc

PhTradeDocFile

TradeDocID

 

 

R_2395

R_2395

PhTenderOffer

PhOrderToDeliverer

TenderOfferID

 

 

R_2400

R_2400

PhReturnToDelType

PhReturnToDelTypeText

ReturnToDelTypeID

 

 

R_2401

R_2401

PhReturnToDelType

PhTradeDocItem

ReturnToDelTypeID

 

 

R_2402

R_2402

PhFormulary

PhFormularyItem

FormularyID

 

 

R_2403

R_2403

PhStItem

PhFormularyItem

StItemID

 

 

R_2404

R_2404

PhResource

PhFormularyItem

ResourceID

 

 

R_2405

R_2405

PhStItem

PhTradeDocDrugAlias

StItemID

 

 

R_2406

R_2406

PhCompany

PhTradeDocDrugAlias

CompanyID

 

 

R_2407

R_2407

PhSt

PhLotInSt

StoragePlaceID

 

 

R_2408

R_2408

PhSt

PhStDocItem

StoragePlaceID

 

 

R_2409

R_2409

PhSt

PhInventory

StoragePlaceID

 

 

R_2410

R_2410

PhSt

PhBasketItem

StID

 

 

R_2411

R_2411

PhStItem

PhBasketItem

StItemID

 

 

R_2412

R_2412

PhSt

PhLStItemStPl

StoragePlaceID

 

 

R_2413

R_2413

PhStItem

PhLStItemStPl

StItemID

 

 

R_2414

R_2414

PhLotInSt

PhAutomaticReservation

LotInStID

 

 

R_2415

R_2415

PhStOrder

PhImportApp

StOrderID

 

 

R_2416

R_2416

PhDrugReactionStatus

PhDrugReactionStatusText

DrugReactionStatusID

 

 

R_2417

R_2417

PhStItem

PhDrugReaction

StItemID

 

 

R_2418

R_2418

PhDrugReactionStatus

PhDrugReaction

StatusID

 

 

R_2419

R_2419

PhDrugReaction

PhDrugReactionComment

DrugReactionID

 

 

R_2420

R_2420

PhSt

PhStPlaceMovement

StID

 

 

R_2421

R_2421

PhSt

PhStPlaceMovement

SourceStPlaceID

 

 

R_2422

R_2422

PhSt

PhStPlaceMovement

DestStPlaceID

 

 

R_2423

R_2423

PhLot

PhStPlaceMovementItem

LotID

 

 

R_2424

R_2424

PhUnit

PhStPlaceMovementItem

UnitID

 

 

R_2425

R_2425

PhStPlaceMovement

PhStPlaceMovementItem

StPlaceMovementID

 

 

R_2426

R_2426

PhStOrderItem

PhReservation

StOrderItemID

 

 

R_2427

R_2427

PhOrderToDelivererItem

PhOrderRealization

OrderToDelivererItemID

 

 

R_2428

R_2428

PhStDocItem

PhOrderRealization

StDocItemID

 

 

R_2429

R_2429

PhUnit

PhOrderRealization

PresentationUnitID

 

 

R_2430

R_2430

PhTenderType

PhTenderOffer

TenderTypeID

 

 

R_2431

R_2431

PhSt

PhOrderCard

StID

 

 

R_2432

R_2432

PhTenderOfferItem

PhOrderCardItem

TenderOfferItemID

 

 

R_2433

R_2433

PhStItem

PhOrderCardItem

StItemID

 

 

R_2434

R_2434

PhOrderCard

PhOrderCardItem

OrderCardID

 

 

R_2435

R_2435

PhOrderCardItem

PhOrderToDelivererItem

OrderCardItemID

 

 

R_2436

R_2436

PhResourceType

PhLResourceTypeUserGroupSt

ResourceTypeID

 

 

R_2437

R_2437

UserGroup

PhLResourceTypeUserGroupSt

UserGroupID

 

 

R_2438

R_2438

PhSt

PhLResourceTypeUserGroupSt

StID

 

 


1  2  3  4  5  6  7  8